from openpyxl import load_workbook

wb = load_workbook("InputData.xlsx")
print(wb.sheetnames)
ws = wb.worksheets[0]

for i in ws["B"]:
    print(i.value)

